
/*
'===============================================================================
'  HNG.Portal.BL.TblWebInfoManager
'===============================================================================
*/

using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using HNG.Portal.BLL;
using HNG.Portal.DAL;
using HNG.Portal.DAL.EntityClasses;
using HNG.Portal.DAL.FactoryClasses;
using HNG.Portal.DAL.HelperClasses;
using SD.LLBLGen.Pro.ORMSupportClasses;

namespace HNG.Portal.BLL
{
	public class TblWebInfoManager : TblWebInfoManagerBase
	{
		/// <summary>
		/// Purpose: Class constructor.
		/// </summary>
		public TblWebInfoManager()
		{
			// Nothing for now.
		}
        public DataTable Get_Bykeysearch(string keysearch, string columnName, int langID)
        {
            SqlConnection Conn = new SqlConnection(HNG.LIB.Common.Connection.strConn);
            string strQuery = "select * from Tblwebinfo ";
            if (columnName != "")
                strQuery += " where " + columnName + " like N'%" + keysearch + "%'" + " AND langID=" + langID + " Order by ID desc";
            else
                strQuery += " where HoTen like N'%" + keysearch + "%'" + " AND langID=" + langID + " Order by ID desc";
            return AE.SqlHelper.ExecuteDataTable(Conn, CommandType.Text, strQuery);
        }

	}
}
